package com.iotechn.unimall.data.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.iotechn.unimall.data.domain.WarehouseOperLogDO;
import com.iotechn.unimall.data.dto.excel.SkuTotalPriceDTO;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;


/**
 * 库存商品表
 * 
 * @author wxw
 * @email 
 * @date 2020-03-24 17:22:46
 */
public interface WarehouseOperLogMapper extends BaseMapper<WarehouseOperLogDO> {

        List<SkuTotalPriceDTO> summaryGoods(@Param("startTime") String startTime, @Param("endTime") String endTime, @Param("skuIds") List<Long> skuIds, @Param("barCodes") List<String> barCodes);
        List<WarehouseOperLogDO> queryWarehouseOperLogDO(@Param("startTime") String startTime, @Param("endTime") String endTime, @Param("skuId") Long skuId, @Param("warehouseId") Long warehouseId, @Param("orderBy") String orderBy);
        List<WarehouseOperLogDO> queryWarehouseOperLogDO_v2(@Param("startTime") String startTime, @Param("endTime") String endTime, @Param("skuId") Long skuId, @Param("warehouseId") Long warehouseId, @Param("orderBy") String orderBy);

        List<WarehouseOperLogDO> selectByPSD(@Param("type") Integer type,@Param("createTime") Date createTime);
}

